﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace DAL
{
  public  class Product
    {
      DataTable dt;
      SqlDataAdapter apd;
        public DataTable Product_All()
        {
            SqlConnection con = Connect.Connected();
            string sql = "SELECT * FROM Product WHERE Status=1";
            SqlCommand cmd = new SqlCommand(sql, con);

             apd = new SqlDataAdapter(cmd);
             dt = new DataTable();
            apd.Fill(dt);
            return dt;
        }
    }
}
